Creating a Database Configuration |
|
Before you begin this task: You must have the role of a systemAdmin or organizationalAdmin to create a database configuration.
You can create a new database configuration to store the database details
- On CUSP > My Applications, click (System Resource Manager). The System Resource Manager window appears.
- Click on the toolbar of System Resource Manager window.
Note:
Alternatively, you can create a database configuration during the following tasks:- Application Package Deployment - In the Provide Required Inputs page, select New Database Configuration option from Select Database Configuration drop-down list. You need to have the role of a systemAdmin to create a database configuration while installing an application.
- Service Group Creation - In the Provide Details for <Connector> page of the New Service Group Wizard, select New Database Configuration option from Select Database Configuration drop-down list. You must have the role of a systemAdmin or organizationalAdmin to create a database configuration while creating a service group.
- Click . A new row is appended to the table and a section to provide database configuration details is displayed in the bottom pane.
- Type the name of the database configuration in the Name field.
- Describe the database configuration in the Description field. This is optional.
- Perform one of the following:
- If you want to use JDBC driver to connect a Service Container to a database:
- Select JDBC option.
- Enter details in the fields.
- If you want to use OLEDB driver to connect a Service Container to a database:
- Select OLEDB option.
- Enter details in the fields.
Note:
- Select Create New Database option to create a database. Provide appropriate details in the DBA Name and DBA password fields.
- You can create a tablespace, if you select Oracle as your JDBC driver or OLEDB Database Vendor.
- If you want to use JDBC driver to connect a Service Container to a database:
- Click (Test Connectivity option) to make sure Process Platform is able to connect to the database with the given parameters.
- Click .
A new database configuration is created and the name, description and, organization (under which the database configuration is being created) are displayed in the new row.
Note: For a new user in Oracle, only Create permissions are granted to the user; for other permissions, you must connect to the Oracle server using the client and select the permissions explicitly.